﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetJuridicoByRUC')
	BEGIN
		DROP  Procedure  GetJuridicoByRUC
	END
GO

CREATE Procedure GetJuridicoByRUC
	@RUC char(11)

AS

BEGIN

	SELECT * FROM Juridico WHERE RUC LIKE (@RUC+'%')

END

GO


GRANT EXEC ON GetJuridicoByRUC TO PUBLIC

GO

